Linking to Records

When using an ODBC application, you can generally either link to a table or import the data from the table to the application. When you link to the table, the data is dynamic. When you import the data, the data is a static copy.

When you link to a table in Microsoft Access, the application prompts you to select the Unique Record Identifier. Only select the identifier if you are using Access for editing records, as it can significantly slow retrieval queries.

You can add two links to the same table.

Example